You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't%' AND titel LIKE '%Laar%'' at line 1 SELECT count(*) as cnt FROM ero WHERE titel LIKE '%Elise%' AND titel LIKE '%van%' AND titel LIKE '%'t%' AND titel LIKE '%Laar%' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't%' AND titel LIKE '%Laar%' ORDER BY titel, alt ASC LIMIT 0, 15' at line 1 SELECT * FROM ero WHERE titel LIKE '%Elise%' AND titel LIKE '%van%' AND titel LIKE '%'t%' AND titel LIKE '%Laar%' ORDER BY titel, alt ASC LIMIT 0, 15